﻿
CREATE PROCEDURE [dbo].[SYS_Provider_IsExist]
(
	@ProviderTypeId  int,
	@Name  varchar(50)
)

AS

DECLARE @TempId int

SELECT @TempId=[ProviderId] FROM dbo.[SYS_Provider] WHERE [ProviderTypeId]=@ProviderTypeId AND [Name]=@Name

IF @TempId IS NULL
	RETURN 0
ELSE
	RETURN 1

